When do you separate databases?

Поиск
Список
Период
Сортировка
От Conrad Schuler
Тема When do you separate databases?
Дата
Msg-id l03130302b6a657c82b5c@[192.168.0.3]
обсуждение исходный текст
Ответы Re: When do you separate databases?
Re: When do you separate databases?
Список pgsql-novice
Hi All,

I am managing a database design project.

It will database our entire website including:

images, articles, bibliography, ecommerce, membership in website, site
statistics, etc.

The 'lumper' team member says "let's make it all one giant database with
dozens and dozens of tables".

The 'splitter' team member says "let's make it many separate databases each
having fewer tables".

What are the advantages and disadvantages to 'lumping' all tables into one
database vs. 'splitting' into multiple databases with fewer tables?

Thanks,

Conrad

+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

Stay informed about the latest changes at masks.org,
sign up for the eNewsletter at:
<http://www.masks.org/about/form_mail/newsletter_subscribe.html>

++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

masks.org survives on your donations.
Please help by mailing a tax-deductible donation to:

masks.org
P.O. Box 12089
Olympia WA 98508
USA

Our website is at:
<http://www.masks.org/>




В списке pgsql-novice по дате отправления:

Предыдущее
От: info@i-developit.com
Дата:
Сообщение: Re: General Database Design Text
Следующее
От: Alfred Perlstein
Дата:
Сообщение: Re: When do you separate databases?